Chris McKay ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	8

About Me

About Me

Area of Expertise	Project Management
About Me	Program and Project Management professional with 20+ years experience in a variety of industries, including Banking & Finance, Management Consulting, Telecommunications, Data Science and Retail. I've only been using Samrtsheet for 9 months now, but I have 15 years experience as an Excel SME including custom solutions using VBA and external Data.
Linkedin	http://www.linkedin.com/in/camckay/

Analytics

383

Posts

0

Visits

1.8k

Points

Sep 20, 2017

Join Date

Aug 14, 2018

Last Active

Reactions

• Insightful 6

  6
• Vote Up 21

  21
• Awesome 1

  1

• Discussions6
• Comments377

• Re: Date validation on Web Form

  Chris McKay

  05/30/18
  Hi, Just to be clear, you would like to know if it's possible to validate the Event Request Date (Date field) in your web form to ensure that the end client cannot select a date that is within the ne…
  1 ·

• Re: Updating Dashboard

  Chris McKay

  04/13/18
  Hi Grant, Yes, blank rows are a real hassle. The Metric widget will use refreshed data automatically and used in combination with Reports and Charts can create some great dynamic results. The Metric …
  1 ·

• Re: PIVOT App

  Chris McKay

  06/04/18
  Hi Jaclyn, Don't panic :-) Unless you specify an update frequency, the Pivot app will only pull the initial data from your source sheet. If the data is not "up-to-the-minute mission critical&quo…
  1 ·

• Re: Status Balls formula help

  Chris McKay

  03/31/18
  Well done! Kind of moot now, but this is how I would have done it: =IF(ISBLANK([Fabric Order Date]1), "Blue", IF([Fabric Received or In Stock]1, "Green", IF(OR([Fabric ETA]1 +3 &l…
  1 ·

• Re: Combine Form Row information into Single Row data

  Chris McKay

  06/08/18
  Hi, The challenge you will have here is ensuring that the unique identifier (e.g. the Building and Unit Number) is consistent across the related rows. Assuming that the process starts with a set of c…
  1 ·

Next